2004-02-18 10:28:41 - SQL (template1): SELECT version() 2004-02-18 10:28:41 - SQL (template1): SELECT datlastsysoid FROM pg_database WHERE datname = 'template1' 2004-02-18 10:28:41 - SQL (template1): SELECT oid, datname, datpath, datallowconn, pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS datowner FROM pg_database ORDER BY datname 2004-02-18 10:28:41 - SQL (template1): SELECT * FROM pg_group ORDER BY groname 2004-02-18 10:28:42 - SQL (template1): SELECT * FROM pg_user ORDER BY usename 2004-02-18 10:28:42 - SQL (template1): SELECT datname, procpid, usename, current_query FROM pg_stat_activity 2004-02-18 10:28:43 - SQL (template1): SELECT datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit FROM pg_stat_database ORDER BY datname 2004-02-18 10:28:45 - SQL (NewFinanc): SELECT oid, * FROM pg_language ORDER BY lanname 2004-02-18 10:28:46 - SQL (NewFinanc): SELECT oid, *, pg_get_userbyid(proowner) as funcowner FROM pg_proc WHERE oid = 0::oid 2004-02-18 10:28:46 - SQL (NewFinanc): SELECT oid, *, pg_get_userbyid(proowner) as funcowner FROM pg_proc WHERE oid = 0::oid 2004-02-18 10:28:46 - SQL (NewFinanc): SELECT oid, *, pg_get_userbyid(proowner) as funcowner FROM pg_proc WHERE oid = 0::oid 2004-02-18 10:28:46 - SQL (NewFinanc): SELECT objoid, objsubid, description FROM pg_description 2004-02-18 10:28:46 - SQL (template1): SELECT numbackends, xact_commit, xact_rollback, blks_read, blks_hit FROM pg_stat_database WHERE datname = 'NewFinanc' 2004-02-18 10:28:49 - SQL (NewFinanc): SELECT oid, aggname, pg_get_userbyid(aggowner) AS owner, aggtransfn, aggfinalfn, aggbasetype, aggtranstype, aggfinaltype, agginitval FROM pg_aggregate ORDER BY aggname 2004-02-18 10:28:49 - SQL (NewFinanc): SELECT oid, typname FROM pg_type 2004-02-18 10:28:49 - SQL (NewFinanc): SELECT oid, *, pg_get_userbyid(proowner) as funcowner FROM pg_proc ORDER BY proname 2004-02-18 10:28:49 - SQL (NewFinanc): SELECT oid, * FROM pg_language 2004-02-18 10:28:54 - SQL (NewFinanc): SELECT oid, *, pg_get_userbyid(oprowner) as opowner FROM pg_operator ORDER BY oprname 2004-02-18 10:28:54 - SQL (NewFinanc): SELECT oid, oprname FROM pg_operator 2004-02-18 10:28:57 - SQL (NewFinanc): SELECT oid, relname, pg_get_userbyid(relowner) AS seqowner, relacl FROM pg_class WHERE relkind = 'S' ORDER BY relname 2004-02-18 10:28:57 - SQL (NewFinanc): SELECT oid, relname, pg_get_userbyid(relowner) as tableowner, relacl, relhasoids FROM pg_class WHERE ((relkind = 'r') OR (relkind = 's')) ORDER BY relname 2004-02-18 10:28:57 - SQL (NewFinanc): SELECT oid, *, pg_get_userbyid(typowner) as typeowner FROM pg_type WHERE typrelid = 0 ORDER BY typname 2004-02-18 10:28:57 - SQL (NewFinanc): SELECT c.oid, c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl, pg_get_viewdef(c.relname) AS definition FROM pg_class c WHERE ((c.relhasrules AND (EXISTS (SELECT r.rulename FROM pg_rewrite r WHERE ((r.ev_class = c.oid) AND (bpchar(r.ev_type) = '1'::bpchar))))) OR (c.relkind = 'v'::"char")) ORDER BY relname 2004-02-18 10:28:59 - SQL (NewFinanc): SELECT relname, n_tup_ins, n_tup_upd, n_tup_del FROM pg_stat_all_tables ORDER BY relname 2004-02-18 10:29:14 - SQL (NewFinanc): SELECT rcname, rcsrc FROM pg_relcheck WHERE NOT EXISTS (SELECT * FROM pg_relcheck AS c, pg_inherits AS i WHERE i.inhrelid = pg_relcheck.rcrelid AND (c.rcname = pg_relcheck.rcname OR (c.rcname[0] = '$' AND pg_relcheck.rcname[0] = '$')) AND c.rcsrc = pg_relcheck.rcsrc AND c.rcrelid = i.inhparent) AND rcrelid = 586096::oid ORDER BY rcname 2004-02-18 10:29:14 - SQL (NewFinanc): SELECT 0::oid AS oid, a.attname, a.attnum, CASE WHEN (t.typlen = -1 AND t.typelem != 0) THEN (SELECT at.typname FROM pg_type at WHERE at.oid = t.typelem) || '[]' ELSE t.typname END AS typname, CASE WHEN ((a.attlen = -1) AND ((a.atttypmod)::int4 = (-1)::int4)) THEN (0)::int4 ELSE CASE WHEN a.attlen = -1 THEN CASE WHEN ((t.typname = 'bpchar') OR (t.typname = 'char') OR (t.typname = 'varchar')) THEN (a.atttypmod -4)::int4 ELSE (a.atttypmod)::int4 END ELSE (a.attlen)::int4 END END AS length, a.attnotnull, (SELECT adsrc FROM pg_attrdef d WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum) AS default, (SELECT indisprimary FROM pg_index i, pg_class ic, pg_attribute ia WHERE i.indrelid = a.attrelid AND i.indexrelid = ic.oid AND ic.oid = ia.attrelid AND ia.attname = a.attname AND indisprimary IS NOT NULL ORDER BY indisprimary DESC LIMIT 1) AS primarykey, a.attstattarget FROM pg_attribute a, pg_type t WHERE a.atttypid = t.oid AND attrelid = 586096::oid ORDER BY attnum 2004-02-18 10:29:14 - SQL (NewFinanc): SELECT c.relname FROM pg_class c, pg_inherits i WHERE c.oid = i.inhparent AND i.inhrelid = 586096::oid ORDER BY inhseqno 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT oid, tgrelid, tgconstrname, tgnargs, tgargs, tgdeferrable, tginitdeferred FROM pg_trigger WHERE tgisconstraint = TRUE AND tgtype = 21 AND tgrelid = 586096::oid ORDER BY tgconstrname 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT i.oid, i.relname, x.indisunique, x.indisprimary, pg_get_indexdef(i.oid) AS definition FROM pg_index x, pg_class i WHERE i.oid = x.indexrelid AND indrelid = 586096::oid ORDER BY relname 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT attname FROM pg_attribute WHERE attrelid = 686368::oid ORDER BY attnum 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT attname FROM pg_attribute WHERE attrelid = 686369::oid ORDER BY attnum 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT attname FROM pg_attribute WHERE attrelid = 586098::oid ORDER BY attnum 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT oid, rulename, pg_get_ruledef(rulename) as definition FROM pg_rewrite WHERE ev_class = 586096::oid ORDER BY rulename 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT t.oid, tgname, proname, tgargs, tgtype FROM pg_trigger t, pg_proc p WHERE t.tgfoid = p.oid AND tgisconstraint = FALSE AND tgrelid = 586096::oid ORDER BY tgname 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT count(*) AS rows FROM pagamentos 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 586096::oid OR t.tgconstrrelid = 0) AND t.tgtype = 9 AND t.tgrelid = c.oid AND c.relname = 'lancamentos' 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 586096::oid OR t.tgconstrrelid = 0) AND t.tgtype = 17 AND t.tgrelid = c.oid AND c.relname = 'lancamentos' 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 586096::oid OR t.tgconstrrelid = 0) AND t.tgtype = 9 AND t.tgrelid = c.oid AND c.relname = 'usuario_financ' 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 586096::oid OR t.tgconstrrelid = 0) AND t.tgtype = 17 AND t.tgrelid = c.oid AND c.relname = 'usuario_financ' 2004-02-18 10:29:15 - SQL (NewFinanc): SELECT seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_stat_all_tables stat, pg_statio_all_tables statio WHERE stat.relid = statio.relid AND stat.relid = 586096::oid 2004-02-18 10:29:18 - SQL (NewFinanc): SELECT count(*) AS count FROM pagamentos 2004-02-18 10:29:18 - SQL (NewFinanc): SELECT * FROM pagamentos 2004-02-18 10:30:37 - SQL (NewFinanc): SELECT * FROM lancamentos WHERE data = '2004-01-02' 2004-02-18 11:12:29 - SQL (AuxFinanc): SELECT oid, * FROM pg_language ORDER BY lanname 2004-02-18 11:12:29 - SQL (AuxFinanc): SELECT oid, *, pg_get_userbyid(proowner) as funcowner FROM pg_proc WHERE oid = 0::oid 2004-02-18 11:12:29 - SQL (AuxFinanc): SELECT oid, *, pg_get_userbyid(proowner) as funcowner FROM pg_proc WHERE oid = 0::oid 2004-02-18 11:12:29 - SQL (AuxFinanc): SELECT oid, *, pg_get_userbyid(proowner) as funcowner FROM pg_proc WHERE oid = 0::oid 2004-02-18 11:12:29 - SQL (AuxFinanc): SELECT objoid, objsubid, description FROM pg_description 2004-02-18 11:12:29 - SQL (template1): SELECT numbackends, xact_commit, xact_rollback, blks_read, blks_hit FROM pg_stat_database WHERE datname = 'AuxFinanc' 2004-02-18 11:12:37 - SQL (AuxFinanc): SELECT oid, aggname, pg_get_userbyid(aggowner) AS owner, aggtransfn, aggfinalfn, aggbasetype, aggtranstype, aggfinaltype, agginitval FROM pg_aggregate ORDER BY aggname 2004-02-18 11:12:37 - SQL (AuxFinanc): SELECT oid, typname FROM pg_type 2004-02-18 11:12:37 - SQL (AuxFinanc): SELECT oid, *, pg_get_userbyid(proowner) as funcowner FROM pg_proc ORDER BY proname 2004-02-18 11:12:37 - SQL (AuxFinanc): SELECT oid, * FROM pg_language 2004-02-18 11:12:44 - SQL (AuxFinanc): SELECT oid, *, pg_get_userbyid(oprowner) as opowner FROM pg_operator ORDER BY oprname 2004-02-18 11:12:45 - SQL (AuxFinanc): SELECT oid, oprname FROM pg_operator 2004-02-18 11:12:47 - SQL (AuxFinanc): SELECT oid, relname, pg_get_userbyid(relowner) AS seqowner, relacl FROM pg_class WHERE relkind = 'S' ORDER BY relname 2004-02-18 11:12:47 - SQL (AuxFinanc): SELECT oid, relname, pg_get_userbyid(relowner) as tableowner, relacl, relhasoids FROM pg_class WHERE ((relkind = 'r') OR (relkind = 's')) ORDER BY relname 2004-02-18 11:12:47 - SQL (AuxFinanc): SELECT oid, *, pg_get_userbyid(typowner) as typeowner FROM pg_type WHERE typrelid = 0 ORDER BY typname 2004-02-18 11:12:48 - SQL (AuxFinanc): SELECT c.oid, c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl, pg_get_viewdef(c.relname) AS definition FROM pg_class c WHERE ((c.relhasrules AND (EXISTS (SELECT r.rulename FROM pg_rewrite r WHERE ((r.ev_class = c.oid) AND (bpchar(r.ev_type) = '1'::bpchar))))) OR (c.relkind = 'v'::"char")) ORDER BY relname 2004-02-18 11:12:51 - SQL (AuxFinanc): SELECT relname, n_tup_ins, n_tup_upd, n_tup_del FROM pg_stat_all_tables ORDER BY relname 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT rcname, rcsrc FROM pg_relcheck WHERE NOT EXISTS (SELECT * FROM pg_relcheck AS c, pg_inherits AS i WHERE i.inhrelid = pg_relcheck.rcrelid AND (c.rcname = pg_relcheck.rcname OR (c.rcname[0] = '$' AND pg_relcheck.rcname[0] = '$')) AND c.rcsrc = pg_relcheck.rcsrc AND c.rcrelid = i.inhparent) AND rcrelid = 687125::oid ORDER BY rcname 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT 0::oid AS oid, a.attname, a.attnum, CASE WHEN (t.typlen = -1 AND t.typelem != 0) THEN (SELECT at.typname FROM pg_type at WHERE at.oid = t.typelem) || '[]' ELSE t.typname END AS typname, CASE WHEN ((a.attlen = -1) AND ((a.atttypmod)::int4 = (-1)::int4)) THEN (0)::int4 ELSE CASE WHEN a.attlen = -1 THEN CASE WHEN ((t.typname = 'bpchar') OR (t.typname = 'char') OR (t.typname = 'varchar')) THEN (a.atttypmod -4)::int4 ELSE (a.atttypmod)::int4 END ELSE (a.attlen)::int4 END END AS length, a.attnotnull, (SELECT adsrc FROM pg_attrdef d WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum) AS default, (SELECT indisprimary FROM pg_index i, pg_class ic, pg_attribute ia WHERE i.indrelid = a.attrelid AND i.indexrelid = ic.oid AND ic.oid = ia.attrelid AND ia.attname = a.attname AND indisprimary IS NOT NULL ORDER BY indisprimary DESC LIMIT 1) AS primarykey, a.attstattarget FROM pg_attribute a, pg_type t WHERE a.atttypid = t.oid AND attrelid = 687125::oid ORDER BY attnum 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT c.relname FROM pg_class c, pg_inherits i WHERE c.oid = i.inhparent AND i.inhrelid = 687125::oid ORDER BY inhseqno 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT oid, tgrelid, tgconstrname, tgnargs, tgargs, tgdeferrable, tginitdeferred FROM pg_trigger WHERE tgisconstraint = TRUE AND tgtype = 21 AND tgrelid = 687125::oid ORDER BY tgconstrname 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT i.oid, i.relname, x.indisunique, x.indisprimary, pg_get_indexdef(i.oid) AS definition FROM pg_index x, pg_class i WHERE i.oid = x.indexrelid AND indrelid = 687125::oid ORDER BY relname 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT attname FROM pg_attribute WHERE attrelid = 777659::oid ORDER BY attnum 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT attname FROM pg_attribute WHERE attrelid = 777660::oid ORDER BY attnum 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT attname FROM pg_attribute WHERE attrelid = 687127::oid ORDER BY attnum 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT oid, rulename, pg_get_ruledef(rulename) as definition FROM pg_rewrite WHERE ev_class = 687125::oid ORDER BY rulename 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT t.oid, tgname, proname, tgargs, tgtype FROM pg_trigger t, pg_proc p WHERE t.tgfoid = p.oid AND tgisconstraint = FALSE AND tgrelid = 687125::oid ORDER BY tgname 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT count(*) AS rows FROM pagamentos 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 687125::oid OR t.tgconstrrelid = 0) AND t.tgtype = 9 AND t.tgrelid = c.oid AND c.relname = 'lancamentos' 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 687125::oid OR t.tgconstrrelid = 0) AND t.tgtype = 17 AND t.tgrelid = c.oid AND c.relname = 'lancamentos' 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 687125::oid OR t.tgconstrrelid = 0) AND t.tgtype = 9 AND t.tgrelid = c.oid AND c.relname = 'usuario_financ' 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 687125::oid OR t.tgconstrrelid = 0) AND t.tgtype = 17 AND t.tgrelid = c.oid AND c.relname = 'usuario_financ' 2004-02-18 11:12:56 - SQL (AuxFinanc): SELECT seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_stat_all_tables stat, pg_statio_all_tables statio WHERE stat.relid = statio.relid AND stat.relid = 687125::oid 2004-02-18 11:12:59 - SQL (AuxFinanc): SELECT count(*) AS count FROM pagamentos 2004-02-18 11:12:59 - SQL (AuxFinanc): SELECT * FROM pagamentos 2004-02-18 11:35:45 - SQL (NewFinanc): SELECT relname, n_tup_ins, n_tup_upd, n_tup_del FROM pg_stat_all_tables ORDER BY relname 2004-02-18 11:38:09 - SQL (NewFinanc): SELECT count(*) AS count FROM lancamentos WHERE exercicio_cod = '3' AND conta_cod = '558' AND data = '2004-1-2' AND seq_lanc = '2' AND valor = '-591,87' AND contra_partida = '12' AND data_lanc = '2004-2-17 10:49:50' AND hist_cod = '2' AND usr_cod = '2' AND tipo_lanc = 'D' AND flag_contas = '0' 2004-02-18 11:38:09 - ******************************************************************* 2004-02-18 11:38:09 - Error(s) 2004-02-18 11:38:09 - ******************************************************************* 2004-02-18 11:38:09 - Error in pgAdmin II:frmSQLOutput.cmdSave_Click: -2147467259 - ERROR: Bad numeric input format '-591,87' 2004-02-18 11:38:09 - The following error(s) have been logged: -2147467259 - ERROR: Bad numeric input format '-591,87' 2004-02-18 11:38:09 - Windows Version: Windows 2000 v5.0 build 2195 Service Pack 2 2004-02-18 11:38:09 - pgSchema Version: 1.6.0 2004-02-18 11:38:09 - MDAC Version: 2.5 2004-02-18 11:38:09 - DBMS Version: 07.03.0100 PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.3 2004-02-18 11:38:09 - Connection String (Master Connection): Provider=MSDASQL.1;Extended Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=infokeeper;PORT=5432;UID=nexion;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0" 2004-02-18 11:39:10 - SQL (NewFinanc): SELECT count(*) AS count FROM lancamentos WHERE exercicio_cod = '3' AND conta_cod = '558' AND data = '2004-1-2' AND seq_lanc = '2' AND valor = '-591,87' AND contra_partida = '12' AND data_lanc = '2004-2-17 10:49:50' AND hist_cod = '2' AND usr_cod = '2' AND tipo_lanc = 'D' AND flag_contas = '0' 2004-02-18 11:39:10 - ******************************************************************* 2004-02-18 11:39:10 - Error(s) 2004-02-18 11:39:10 - ******************************************************************* 2004-02-18 11:39:10 - Error in pgAdmin II:frmSQLOutput.cmdSave_Click: -2147467259 - ERROR: Bad numeric input format '-591,87' 2004-02-18 11:39:10 - The following error(s) have been logged: -2147467259 - ERROR: Bad numeric input format '-591,87' 2004-02-18 11:39:10 - Windows Version: Windows 2000 v5.0 build 2195 Service Pack 2 2004-02-18 11:39:10 - pgSchema Version: 1.6.0 2004-02-18 11:39:10 - MDAC Version: 2.5 2004-02-18 11:39:10 - DBMS Version: 07.03.0100 PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.3 2004-02-18 11:39:10 - Connection String (Master Connection): Provider=MSDASQL.1;Extended Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=infokeeper;PORT=5432;UID=nexion;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0" 2004-02-18 11:43:33 - SQL (NewFinanc): SELECT rcname, rcsrc FROM pg_relcheck WHERE NOT EXISTS (SELECT * FROM pg_relcheck AS c, pg_inherits AS i WHERE i.inhrelid = pg_relcheck.rcrelid AND (c.rcname = pg_relcheck.rcname OR (c.rcname[0] = '$' AND pg_relcheck.rcname[0] = '$')) AND c.rcsrc = pg_relcheck.rcsrc AND c.rcrelid = i.inhparent) AND rcrelid = 585988::oid ORDER BY rcname 2004-02-18 11:43:33 - SQL (NewFinanc): SELECT 0::oid AS oid, a.attname, a.attnum, CASE WHEN (t.typlen = -1 AND t.typelem != 0) THEN (SELECT at.typname FROM pg_type at WHERE at.oid = t.typelem) || '[]' ELSE t.typname END AS typname, CASE WHEN ((a.attlen = -1) AND ((a.atttypmod)::int4 = (-1)::int4)) THEN (0)::int4 ELSE CASE WHEN a.attlen = -1 THEN CASE WHEN ((t.typname = 'bpchar') OR (t.typname = 'char') OR (t.typname = 'varchar')) THEN (a.atttypmod -4)::int4 ELSE (a.atttypmod)::int4 END ELSE (a.attlen)::int4 END END AS length, a.attnotnull, (SELECT adsrc FROM pg_attrdef d WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum) AS default, (SELECT indisprimary FROM pg_index i, pg_class ic, pg_attribute ia WHERE i.indrelid = a.attrelid AND i.indexrelid = ic.oid AND ic.oid = ia.attrelid AND ia.attname = a.attname AND indisprimary IS NOT NULL ORDER BY indisprimary DESC LIMIT 1) AS primarykey, a.attstattarget FROM pg_attribute a, pg_type t WHERE a.atttypid = t.oid AND attrelid = 585988::oid ORDER BY attnum 2004-02-18 11:43:33 - SQL (NewFinanc): SELECT c.relname FROM pg_class c, pg_inherits i WHERE c.oid = i.inhparent AND i.inhrelid = 585988::oid ORDER BY inhseqno 2004-02-18 11:43:33 - SQL (NewFinanc): SELECT oid, tgrelid, tgconstrname, tgnargs, tgargs, tgdeferrable, tginitdeferred FROM pg_trigger WHERE tgisconstraint = TRUE AND tgtype = 21 AND tgrelid = 585988::oid ORDER BY tgconstrname 2004-02-18 11:43:33 - SQL (NewFinanc): SELECT i.oid, i.relname, x.indisunique, x.indisprimary, pg_get_indexdef(i.oid) AS definition FROM pg_index x, pg_class i WHERE i.oid = x.indexrelid AND indrelid = 585988::oid ORDER BY relname 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT attname FROM pg_attribute WHERE attrelid = 686354::oid ORDER BY attnum 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT attname FROM pg_attribute WHERE attrelid = 686353::oid ORDER BY attnum 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT attname FROM pg_attribute WHERE attrelid = 585990::oid ORDER BY attnum 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT oid, rulename, pg_get_ruledef(rulename) as definition FROM pg_rewrite WHERE ev_class = 585988::oid ORDER BY rulename 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT t.oid, tgname, proname, tgargs, tgtype FROM pg_trigger t, pg_proc p WHERE t.tgfoid = p.oid AND tgisconstraint = FALSE AND tgrelid = 585988::oid ORDER BY tgname 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT count(*) AS rows FROM lancamentos 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 585988::oid OR t.tgconstrrelid = 0) AND t.tgtype = 9 AND t.tgrelid = c.oid AND c.relname = 'contas' 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 585988::oid OR t.tgconstrrelid = 0) AND t.tgtype = 17 AND t.tgrelid = c.oid AND c.relname = 'contas' 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 585988::oid OR t.tgconstrrelid = 0) AND t.tgtype = 9 AND t.tgrelid = c.oid AND c.relname = 'exercicio' 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 585988::oid OR t.tgconstrrelid = 0) AND t.tgtype = 17 AND t.tgrelid = c.oid AND c.relname = 'exercicio' 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 585988::oid OR t.tgconstrrelid = 0) AND t.tgtype = 9 AND t.tgrelid = c.oid AND c.relname = 'usuario_financ' 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT proname, tgconstrname FROM pg_proc p, pg_trigger t, pg_class c WHERE p.oid = t.tgfoid AND (t.tgconstrrelid = 585988::oid OR t.tgconstrrelid = 0) AND t.tgtype = 17 AND t.tgrelid = c.oid AND c.relname = 'usuario_financ' 2004-02-18 11:43:34 - SQL (NewFinanc): SELECT seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_stat_all_tables stat, pg_statio_all_tables statio WHERE stat.relid = statio.relid AND stat.relid = 585988::oid